Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
EmployeeCommissionPlanID (FK)(PK) | A unique reference number for an employee's commission plan. This may be the employee's payroll number. | ID_PLN_EM_CMN | Code4 | char(4) | WorkerCommissionPlan(CO_PLN_EM_CMN) |
MerchandiseHierarchyGroupID (FK)(PK) | Unique system assigned identifier for a group or class of merchandise. | ID_MRHRC_GP | Identity | integer | MerchandiseHierarchyGroup(CO_MRHRC_GP) |
AssociateActionID (FK)(PK) | A unique system assigned identifier for an action that is performed by a Worker while assisting a customer purchasing the merchandise or services. | ID_ACTN_ASCTE | Code2 | char(2) | SalesAssociateAction(CO_SLS_ASCTE_ACTN) |
CommissionPercent | The percentage of the Item's actual selling price that the Worker receives as part of their CommissionPlan. | PE_CMN | Percent | decimal(7,4) | |
CommissionAmount | A fixed monetary amount a Worker receives as part of their CommissionPlan. | MO_CMN | Money | decimal(16,5) | |